package com.jt.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jt.pojo.User;
import com.jt.vo.PageResult;
import org.apache.ibatis.annotations.*;


import java.util.List;
//继承时，必须添加泛型，该泛型必须与表关联
//MP提供了强大的单表CRUD操作，多表操作自己写
public interface UserMapper extends BaseMapper<User> {

    List<User> findAll();

    //登录界面
    User finUserByUP(User user);

    @Select("SELECT COUNT(1) FROM user")
    Long findTotal();

    //只支持单值传参  封装为map集合
    List<User> findUserList(@Param("start") int start,
                            @Param("size") int size,
                            @Param("query") String query);

    @Update("update user set status = #{status},updated = #{updated} where id = #{id}")
    void updateStatus(User user);

    @Delete("delete from user where id = #{id}")
    void deleteUser(int id);

    void addUser(User user);

    User findUserById(Integer id);


    void updateUser(User user);
}

